Skip to main content

Schedule Pipeline

Introduction

The pipeline is a new type of dataset added to the OPNBI Application. Users can Define the relationship between different datasets and as well as tables with user-friendly UI. With Pipeline, no SQL knowledge is needed to provide join between tables and datasets available in OPNBI. For Schedule Pipeline, you have to use the Parameter dataset and create PDS Pipeline.

Prerequisites

To Schedule a Pipeline, you need working Parameter Datasets(JDBC) and a list of tables and views.

Objective

How to Schedule Pipeline.

Download Pipeline.zip file from link given Pipeline.zip

Follow steps to create Reverse Join Pipeline in OPNBI:-

Login to the OPNBI application with valid user credentials.

Go to Master Data > Dataset section from the Hamburger menu.

Docusaurus Slash Introduction

Go to the Dataset section, Click on Create Pipeline from the bottom menu bar. As shown in the figure below:

Docusaurus Slash Introduction

Once you click, you can see a blank create pipeline window as in the below image:

Docusaurus Slash Introduction

Enter the Following detail in the Pipeline dialog box:

Name: Schedule

Source: OPNBI-mapping

Expand Dataset from the left side table view, As shown in the figure below:

Docusaurus Slash Introduction

Drag and Drop the Country Parameter Dataset from the Dataset box and drag to the diagram box at the right side, and select all the columns from the Select Column dialog box, as shown in the figure below:

Docusaurus Slash Introduction

Click on Submit button, after dragging & drop Country Parameter Dataset in the diagram box, look like the figure below:

Docusaurus Slash Introduction

Drag and drop the second table, take Office Parameter Dataset, and drop it in the diagram box.

After dropping the Office Parameter Dataset, select all the columns from the Select Columns dialog box, as shown in the figure below:

Docusaurus Slash Introduction

Click on submit button, Country Parameter and office Parameter Dataset from diagram box will look like the figure below:

Docusaurus Slash Introduction

After adding Country Parameter and office Parameter from the Dataset list, Drag the Country column from Country Parameter to Office Parameter, as shown in the figure below:

Docusaurus Slash Introduction

Click on Submit to save the Pipeline.

Now, In Dataset Section go to the Pipeline which you created click on the Schedule Pipeline iconDocusaurus Slash Introduction to schedule the pipeline, as shown in the figure below:

Docusaurus Slash Introduction

Click on the Schedule Pipeline icon and it will display the screen below:

Docusaurus Slash Introduction

Enter the Parameter name in Country Parameter and Office Parameter, here we are giving USA country name in both the dataset, as shown in the figure below:

Docusaurus Slash Introduction

In the Schedule tab, you can set frequency as per your requirement.

In the Output tab, the format must be PDS, and also you can give suffix, as shown in the figure below:

Docusaurus Slash Introduction

Click on Run Button to schedule Pipeline and you will get the message Schedule Successfully.

Go to the Request > Request section from the Hamburger menu.

In the Request section you can see the Schedule request completed, as shown in the figure below:

Docusaurus Slash Introduction

Now go to the MasterData > Dataset, and you can see that Schedule Pds is Created, as shown in the figure below:

Docusaurus Slash Introduction

The pipeline is run in the Adhoc Analysis.

Go to Documents > Adhoc Analysis section from the hamburger menu.

In Adhoc Analysis click on the + icon to create a new Analysis, as shown in the figure below:

Docusaurus Slash Introduction

When you click on create Analysis then the Analysis Selection dialog box will open, as shown in the figure below:

Docusaurus Slash Introduction

Enter the following details in Analysis Section:

Dataset: Schedule (PDS) (select the Pipeline, which you are created)

The two tables will get load the left side box of Pipeline view, Now expends the Country Parameter table, as shown in the figure below:

Docusaurus Slash Introduction

Drag and drop CITY, State column from Country Parameter to Rows, Drag and drop a Country column from OFFICE Parameter and Put it in Column box, Drag and drop the Office code column from Office Parameter to Values box (Select count in Type), as shown in the figure below:

Docusaurus Slash Introduction

Click on Preview Button it will show the output and after the preview click on Cancel Button it will show the screen as follows:

Docusaurus Slash Introduction

Click on Save asDocusaurus Slash Introduction icon for saving the Analysis, it will show the screen as below:

Docusaurus Slash Introduction